/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 80031 (8.0.31)
 Source Host           : localhost:3306
 Source Schema         : library_db

 Target Server Type    : MySQL
 Target Server Version : 80031 (8.0.31)
 File Encoding         : 65001

 Date: 10/05/2025 12:52:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for books
-- ----------------------------
DROP TABLE IF EXISTS `books`;
CREATE TABLE `books` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '书籍ID',
  `isbn` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ISBN号',
  `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '书名',
  `author` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '作者',
  `publisher` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '出版社',
  `publish_date` date DEFAULT NULL COMMENT '出版日期',
  `category` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分类',
  `description` text COLLATE utf8mb4_unicode_ci COMMENT '描述',
  `cover_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '封面图片URL',
  `total_copies` int NOT NULL DEFAULT '0' COMMENT '总册数',
  `available_copies` int NOT NULL DEFAULT '0' COMMENT '可借册数',
  `location` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '馆藏位置',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：0-下架，1-正常',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `isbn` (`isbn`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='书籍表';

-- ----------------------------
-- Records of books
-- ----------------------------
BEGIN;
INSERT INTO `books` (`id`, `isbn`, `title`, `author`, `publisher`, `publish_date`, `category`, `description`, `cover_image`, `total_copies`, `available_copies`, `location`, `status`, `create_time`, `update_time`) VALUES (1, '978-7-302-12345-6', 'Java 编程思想', 'Bruce Eckel', '机械工业出版社', '2020-05-15', '计算机', '经典 Java 编程书籍', 'cover1.jpg', 10, 8, 'A1', 1, '2025-05-09 21:02:08', '2025-05-09 23:37:24');
INSERT INTO `books` (`id`, `isbn`, `title`, `author`, `publisher`, `publish_date`, `category`, `description`, `cover_image`, `total_copies`, `available_copies`, `location`, `status`, `create_time`, `update_time`) VALUES (2, '978-7-115-67890-2', '深入理解计算机系统', 'Randal E. Bryant', '人民邮电出版社', '2018-08-10', '计算机', '计算机系统入门', 'cover2.jpg', 15, 10, 'B2', 1, '2025-05-09 21:02:08', '2025-05-10 12:50:34');
INSERT INTO `books` (`id`, `isbn`, `title`, `author`, `publisher`, `publish_date`, `category`, `description`, `cover_image`, `total_copies`, `available_copies`, `location`, `status`, `create_time`, `update_time`) VALUES (3, '978-7-118-56789-3', '数据结构与算法分析', 'Mark A. Weiss', '清华大学出版社', '2019-07-20', '计算机', '数据结构经典', 'cover3.jpg', 20, 11, 'C3', 1, '2025-05-09 21:02:08', '2025-05-09 23:06:40');
INSERT INTO `books` (`id`, `isbn`, `title`, `author`, `publisher`, `publish_date`, `category`, `description`, `cover_image`, `total_copies`, `available_copies`, `location`, `status`, `create_time`, `update_time`) VALUES (4, '978-7-543-12345-1', 'C++ Primer', 'Stanley B. Lippman', '电子工业出版社', '2021-06-30', '计算机', 'C++ 入门书籍', 'cover4.jpg', 12, 7, 'D4', 1, '2025-05-09 21:02:08', '2025-05-10 00:02:11');
INSERT INTO `books` (`id`, `isbn`, `title`, `author`, `publisher`, `publish_date`, `category`, `description`, `cover_image`, `total_copies`, `available_copies`, `location`, `status`, `create_time`, `update_time`) VALUES (5, '978-7-532-98765-4', '人工智能：一种现代方法', 'Stuart Russell', '人民邮电出版社', '2022-03-18', '人工智能', 'AI 基础理论', 'cover5.jpg', 18, 14, 'E5', 1, '2025-05-09 21:02:08', '2025-05-10 00:22:45');
INSERT INTO `books` (`id`, `isbn`, `title`, `author`, `publisher`, `publish_date`, `category`, `description`, `cover_image`, `total_copies`, `available_copies`, `location`, `status`, `create_time`, `update_time`) VALUES (6, '978-7-5093-67890-5', '操作系统原理', 'Andrew S. Tanenbaum', '高等教育出版社', '2020-11-25', '计算机', '操作系统经典教材', 'cover6.jpg', 10, 5, 'F6', 1, '2025-05-09 21:02:08', '2025-05-09 21:02:08');
INSERT INTO `books` (`id`, `isbn`, `title`, `author`, `publisher`, `publish_date`, `category`, `description`, `cover_image`, `total_copies`, `available_copies`, `location`, `status`, `create_time`, `update_time`) VALUES (7, '978-7-115-23456-7', '编译原理', 'Alfred V. Aho', '机械工业出版社', '2019-02-10', '计算机', '龙书，编译器入门', 'cover7.jpg', 8, 4, 'G7', 1, '2025-05-09 21:02:08', '2025-05-09 21:02:08');
INSERT INTO `books` (`id`, `isbn`, `title`, `author`, `publisher`, `publish_date`, `category`, `description`, `cover_image`, `total_copies`, `available_copies`, `location`, `status`, `create_time`, `update_time`) VALUES (8, '978-7-508-56789-1', '深度学习', 'Ian Goodfellow', '清华大学出版社', '2018-09-05', '人工智能', '深度学习经典', 'cover8.jpg', 16, 12, 'H8', 1, '2025-05-09 21:02:08', '2025-05-09 21:02:08');
INSERT INTO `books` (`id`, `isbn`, `title`, `author`, `publisher`, `publish_date`, `category`, `description`, `cover_image`, `total_copies`, `available_copies`, `location`, `status`, `create_time`, `update_time`) VALUES (9, '978-7-5432-98765-3', 'Python 编程快速上手', 'Al Sweigart', '人民邮电出版社', '2021-12-01', '计算机', 'Python 基础', 'cover9.jpg', 25, 18, 'I9', 1, '2025-05-09 21:02:08', '2025-05-09 21:02:08');
INSERT INTO `books` (`id`, `isbn`, `title`, `author`, `publisher`, `publish_date`, `category`, `description`, `cover_image`, `total_copies`, `available_copies`, `location`, `status`, `create_time`, `update_time`) VALUES (10, '978-7-5023-87654-2', '数据挖掘导论', 'Pang-Ning Tan', '电子工业出版社', '2020-07-15', '大数据', '数据挖掘概念', 'f1749a6f-ebea-4373-9f17-8412f84511e8.jpg', 20, 15, 'J10', 1, '2025-05-09 21:02:08', '2025-05-10 12:06:56');
INSERT INTO `books` (`id`, `isbn`, `title`, `author`, `publisher`, `publish_date`, `category`, `description`, `cover_image`, `total_copies`, `available_copies`, `location`, `status`, `create_time`, `update_time`) VALUES (15, '123', '啊啊啊啊', '123', '123', '2025-05-13', '123', '213', '7ca16da4-f771-47cb-9ed7-1d6ecc123711.jpg', 2, 1, '123', 1, '2025-05-10 01:14:20', '2025-05-10 12:50:26');
INSERT INTO `books` (`id`, `isbn`, `title`, `author`, `publisher`, `publish_date`, `category`, `description`, `cover_image`, `total_copies`, `available_copies`, `location`, `status`, `create_time`, `update_time`) VALUES (17, '123124141', '猜猜猜', '尺寸', '123214', '2025-05-11', '啊', '1额', '8b2966a9-a8d7-4416-a31c-25cac3a6ba3b.jpg', 2, 2, '123', 1, '2025-05-10 12:46:56', '2025-05-10 12:47:04');
COMMIT;

-- ----------------------------
-- Table structure for borrow_records
-- ----------------------------
DROP TABLE IF EXISTS `borrow_records`;
CREATE TABLE `borrow_records` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '借阅记录ID',
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `book_id` bigint NOT NULL COMMENT '书籍ID',
  `borrow_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '借阅时间',
  `due_date` datetime NOT NULL COMMENT '应还时间',
  `return_date` datetime DEFAULT NULL COMMENT '实际归还时间',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：0-已归还，1-借阅中，2-逾期未还',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `book_id` (`book_id`),
  CONSTRAINT `borrow_records_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `borrow_records_ibfk_2` FOREIGN KEY (`book_id`) REFERENCES `books` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='借阅记录表';

-- ----------------------------
-- Records of borrow_records
-- ----------------------------
BEGIN;
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (1, 1, 1, '2025-04-01 10:30:00', '2025-05-30 10:30:00', '2025-05-09 23:37:25', 0, '2025-05-09 21:02:17', '2025-05-09 23:37:24');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (2, 2, 3, '2025-03-15 15:45:00', '2025-04-15 15:45:00', '2025-04-10 15:45:00', 0, '2025-05-09 21:02:17', '2025-05-09 21:02:17');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (3, 3, 5, '2025-02-20 14:00:00', '2025-03-20 14:00:00', NULL, 2, '2025-05-09 21:02:17', '2025-05-09 21:02:17');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (4, 4, 7, '2025-01-10 09:30:00', '2025-02-10 09:30:00', '2025-02-05 09:30:00', 0, '2025-05-09 21:02:17', '2025-05-09 21:02:17');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (5, 5, 9, '2025-05-01 16:20:00', '2025-06-01 16:20:00', NULL, 1, '2025-05-09 21:02:17', '2025-05-09 21:02:17');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (6, 6, 2, '2025-04-10 11:15:00', '2025-05-10 11:15:00', '2025-05-05 11:15:00', 0, '2025-05-09 21:02:17', '2025-05-09 21:02:17');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (7, 7, 4, '2025-03-05 13:40:00', '2025-04-05 13:40:00', NULL, 2, '2025-05-09 21:02:17', '2025-05-09 21:02:17');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (8, 8, 6, '2025-02-01 08:50:00', '2025-03-01 08:50:00', '2025-02-28 08:50:00', 0, '2025-05-09 21:02:17', '2025-05-09 21:02:17');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (9, 9, 8, '2025-01-20 12:10:00', '2025-02-20 12:10:00', NULL, 2, '2025-05-09 21:02:17', '2025-05-09 21:02:17');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (10, 10, 10, '2025-05-05 14:45:00', '2025-06-05 14:45:00', NULL, 1, '2025-05-09 21:02:17', '2025-05-09 21:02:17');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (11, 1, 2, '2025-05-09 22:58:43', '2025-11-05 22:58:43', '2025-05-10 12:50:35', 0, '2025-05-09 22:58:43', '2025-05-10 12:50:34');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (12, 1, 3, '2025-05-09 23:06:41', '2026-01-04 23:06:41', NULL, 1, '2025-05-09 23:06:40', '2025-05-10 00:01:57');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (13, 1, 4, '2025-05-10 00:02:11', '2025-06-09 00:02:11', NULL, 1, '2025-05-10 00:02:11', '2025-05-10 00:02:11');
INSERT INTO `borrow_records` (`id`, `user_id`, `book_id`, `borrow_date`, `due_date`, `return_date`, `status`, `create_time`, `update_time`) VALUES (14, 1, 15, '2025-05-10 12:50:26', '2025-06-09 12:50:26', NULL, 1, '2025-05-10 12:50:26', '2025-05-10 12:50:26');
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
  `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码',
  `real_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '真实姓名',
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `role` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'USER' COMMENT '角色：ADMIN-管理员，USER-普通用户',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：0-禁用，1-正常',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户表';

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (1, '1', '1', 'zhaoyun', '17752890303', '1232@qq.com', 'USER', 1, '2025-05-09 20:58:09', '2025-05-10 12:48:27');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (2, 'a', 'a', '程颖', '15383989471', 'xiulan34@gmail.com', 'ADMIN', 1, '2025-05-09 20:58:09', '2025-05-09 20:58:30');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (3, 'jingchen', '&iqPoscSG)4m', '徐兰英', '13659179533', 'guiying35@jingmin.cn', 'USER', 1, '2025-05-09 20:58:09', '2025-05-09 20:58:09');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (4, 'zhangsan', '123456', '张三', '18812345678', 'zhangsan@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (5, 'lisi', 'abcdef', '李四', '17798765432', 'lisi@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (6, 'wangwu', 'password123', '王五', '13666668888', 'wangwu@example.com', 'ADMIN', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (7, 'zhaoliu', 'test@123', '赵六', '13899997777', 'zhaoliu@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (8, 'tianqi', 'helloWorld', '田七', '15987654321', 'tianqi@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (9, 'xiaoming', 'abc123456', '小明', '13912344321', 'xiaoming@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (10, 'xiaohong', '789xyz', '小红', '15566667777', 'xiaohong@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (11, 'lisiang', 'mypassword', '李想', '13099998888', 'lisiang@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (12, 'zhangwei', 'password!', '张伟', '18655556666', 'zhangwei@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (13, 'chenyan', 'abcd@1234', '陈燕', '13177778888', 'chenyan@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (14, 'lihua', '987654321', '李华', '18566665555', 'lihua@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (15, 'sunyang', 'pass2023', '孙阳', '18099997777', 'sunyang@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (16, 'wanghong', 'abcd1234', '王红', '18966668888', 'wanghong@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (17, 'mafei', 'hello123', '马飞', '15255559999', 'mafei@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (18, 'dongfang', 'goodpass', '东方', '15766667777', 'dongfang@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (19, 'jinming', 'securepwd', '金明', '13677778888', 'jinming@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (20, 'fengyu', 'mypass567', '风雨', '17655556666', 'fengyu@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (21, 'ouyang', 'testpassword', '欧阳', '18299998888', 'ouyang@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (22, 'zhouli', 'bestpass', '周丽', '13888889999', 'zhouli@example.com', 'USER', 1, '2025-05-09 21:01:52', '2025-05-09 21:01:52');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (24, 'ad', '202cb962ac59075b964b07152d234b70', '阿大', '17712312312', '12@qq.com', 'ADMIN', 1, '2025-05-10 00:14:59', '2025-05-10 00:14:59');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (25, 'aaaaa', 'e10adc3949ba59abbe56e057f20f883e', '', '17312312312', 'aaa@qq.com', 'USER', 1, '2025-05-10 12:36:19', '2025-05-10 12:36:19');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (26, 'vvv', 'vvvvvv', '', '17333333333', '740@qq.com', 'USER', 1, '2025-05-10 12:42:16', '2025-05-10 12:42:16');
INSERT INTO `users` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `role`, `status`, `create_time`, `update_time`) VALUES (28, 'vvvvvvvv', 'bbbbbb', '123', '17333333333', '74@1.com', 'USER', 1, '2025-05-10 12:47:38', '2025-05-10 12:47:54');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
